UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b+gZ2VGgtNXxEJk497kIiLAWrJ5tPitoCZ/ULNN+6W0='
WHERE
key_id = '3e5da8e8ab7b3714c7ba37aa1f5fc3990f117dc3d153ddc967ae7aa7dd7a047c'
AND (
token = 'b+gZ2VGgtNXxEJk497kIiLAWrJ5tPitoCZ/ULNN+6W0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)