UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZB0Uu8+2I2kY+F8Tjv91Xm5FsJwV+xUXZoQGQiCFkbk='
WHERE
key_id = 'f478de473126e158a4ccb3b22249a782c3be7b33eac400ba1dcea7fc78bee538'
AND (
token = 'ZB0Uu8+2I2kY+F8Tjv91Xm5FsJwV+xUXZoQGQiCFkbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)