UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GQbSYaTnTerdXfWn5f0uLwNCXVpLU9Oh2hKSFCDLfo8='
WHERE
key_id = 'd478e42fc137d070a8f63c4c7aa599c0900a64bb41aa987098e50b59f318b91e'
AND (
token = 'GQbSYaTnTerdXfWn5f0uLwNCXVpLU9Oh2hKSFCDLfo8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)