UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cdFsxaii8g3K0dqhJq7Yve4Dve10XPr3pVz8tOjjuzc='
WHERE
key_id = '9e1546c85686c3cf07385062ffe2bc61e1185753262d0e6705983ad75a2fa57f'
AND (
token = 'cdFsxaii8g3K0dqhJq7Yve4Dve10XPr3pVz8tOjjuzc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)