UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DgOag6Z3L1qvEZReLsiaMSuLg5hlpGjoiNSAuht2+3s='
WHERE
key_id = '3a6c3166b4ccbde87635c9014243fa134c429a3d396bc2806226f7553ed6b3ef'
AND (
token = 'DgOag6Z3L1qvEZReLsiaMSuLg5hlpGjoiNSAuht2+3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)