UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SCnSfRFiNU+WvNmy9E6NarRU0rQv7rz5Sg4TmG5Tml8='
WHERE
key_id = 'a1fb82847d941a47b62477c812207102302865c00a5ea1d96a436e996baaff13'
AND (
token = 'SCnSfRFiNU+WvNmy9E6NarRU0rQv7rz5Sg4TmG5Tml8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)