UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W28fRQj/hl+LU0jAPGeMKXmXh3ggRVMQMY6IrttOnV4='
WHERE
key_id = 'f2f419ac0fe6d75b43aa169db9f006387fa7ac08336dcf4fb068327069f411bb'
AND (
token = 'W28fRQj/hl+LU0jAPGeMKXmXh3ggRVMQMY6IrttOnV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)