UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X8RbF9dXPtyWg8dnj80GBJShSbfKhbYOXvkGQzOcM1A='
WHERE
key_id = '9ef824dc2152d74adb8006c346b4dd8cf3f3c7468a41ff1e0498570e4bb44ddf'
AND (
token = 'X8RbF9dXPtyWg8dnj80GBJShSbfKhbYOXvkGQzOcM1A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)