UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/hUAwl2xPE9xKY9DTed2Sw7Ol7Avlpunex1xKV+pvac='
WHERE
key_id = 'c7a6a4bd06e21dd94067f4d4b89b63e339769e9010e300b1dfe1514d84ec8c7f'
AND (
token = '/hUAwl2xPE9xKY9DTed2Sw7Ol7Avlpunex1xKV+pvac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)