UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zPTjKfpRXvDAR23FcTl1GfwMpkYlo9cmxPaJCr20RLQ='
WHERE
key_id = '84d8cff42803480c74382f007ea2613ec27ebc34020e8333631fc56817a74f68'
AND (
token = 'zPTjKfpRXvDAR23FcTl1GfwMpkYlo9cmxPaJCr20RLQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)