UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z3kf12G9OmYKRlyIjcpAHf1W/IS8HwGLap1wPDFMt58='
WHERE
key_id = '8ef55bbcb2e14de97821bc9a5eb902cbbf9605f43475e682344206b5d69bd315'
AND (
token = 'z3kf12G9OmYKRlyIjcpAHf1W/IS8HwGLap1wPDFMt58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)