UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zsw6cpyeH8Kk7iZI2zxdSne/GTOQCU0+v+TzrnIjZzE='
WHERE
key_id = 'd06a53c89415dce4ab879842c953be4f8870161604c8c7e71c03decafc9e9051'
AND (
token = 'zsw6cpyeH8Kk7iZI2zxdSne/GTOQCU0+v+TzrnIjZzE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)