UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sbMd5r8QcG/wrfuHjDzzgeL2MDpxcGaMkT2Z4aAbswM='
WHERE
key_id = '4327c3c612c9bc527e479638f861072948a80e2ba9c0ece6197f7fe1be4a6ca8'
AND (
token = 'sbMd5r8QcG/wrfuHjDzzgeL2MDpxcGaMkT2Z4aAbswM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)