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