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