UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/aYKE7YSC1uD1DT+cCI/ifkTPwTTs+YodXz/U77QXI8='
WHERE
key_id = '278cc2cfdeb3c2e89a08f1841f92398f07bc39fce90eaa987086eb402f93bbe2'
AND (
token = '/aYKE7YSC1uD1DT+cCI/ifkTPwTTs+YodXz/U77QXI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)