UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5yrPDnTB42USv/2gabQIbbFhOwCIEelM3chw99+XRc0='
WHERE
key_id = '93567184043485d7cc467db4bda51aae9a6a5773730910ce4514139d745e22a9'
AND (
token = '5yrPDnTB42USv/2gabQIbbFhOwCIEelM3chw99+XRc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)