UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0CdJ6v31dHbAHcTk6ARd6fA6cMqAWjZroLT3IU8bfSQ='
WHERE
key_id = 'cba1c56ba81435a50c4b9be3e07e7acf61310189b8e1d6dd0be2456eb69c547a'
AND (
token = '0CdJ6v31dHbAHcTk6ARd6fA6cMqAWjZroLT3IU8bfSQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)