UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6eHypUqZd06Qytn0D0qct27B5hjDm1KT5hWn5H03NPc='
WHERE
key_id = '17f9f5526797a3d79196f27c5e75034fbd389f1e25e78b65cd18aa1a7e9912a0'
AND (
token = '6eHypUqZd06Qytn0D0qct27B5hjDm1KT5hWn5H03NPc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)