UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yteThP+mGeuiKU+0h/+KGuFOeMP2YbMcrBgA9wDCCF8='
WHERE
key_id = 'af3ca42e0ee4a4ec41449e6d467ac2f9e664c3d608bea5e2c33b3a96e25f5305'
AND (
token = 'yteThP+mGeuiKU+0h/+KGuFOeMP2YbMcrBgA9wDCCF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)