UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cihkOzp1wcDxrKeP1uwVAfImjaCHppLYjJZnnGlg2Os='
WHERE
key_id = '2f67d2d5dec894e546487536ccaaf4bbf31f3f3da9af4f0362f0acc24a03d7e9'
AND (
token = 'cihkOzp1wcDxrKeP1uwVAfImjaCHppLYjJZnnGlg2Os='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)