UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'plqZ0o0Tht5GZoX/W3dXYN/eprU19mjyk5ptG+igAmA='
WHERE
key_id = 'bdfc2ec15b8b5bf79a53638507bbce88c1d7bf645fe380d21f9b8b1cdc50be08'
AND (
token = 'plqZ0o0Tht5GZoX/W3dXYN/eprU19mjyk5ptG+igAmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)