UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KcnweTmGMbQQ+rRoI3iOQmr+u6DWnczhmpL9XSB1RWU='
WHERE
key_id = '2c379814ac111978e29107ee8965dcf2bfc12c90902d512214d340612804dec5'
AND (
token = 'KcnweTmGMbQQ+rRoI3iOQmr+u6DWnczhmpL9XSB1RWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)