UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iLhsR0fJ7kpd1fSDdX66j+NBOJY8eewobZ+dD2aGLb4='
WHERE
key_id = 'b657cd289840bfc7fe299ce854d0c3ccc02a04d6d4f13446b4a2706c14101b31'
AND (
token = 'iLhsR0fJ7kpd1fSDdX66j+NBOJY8eewobZ+dD2aGLb4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)