UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HM1zHlLomeoKFYTvmELtVyeQ5uvMYejrFCvFd5QcZHU='
WHERE
key_id = '9b19b0f79ea1e0e5ca057575b6217ad47b99705122a14150ffe413a1bf771abe'
AND (
token = 'HM1zHlLomeoKFYTvmELtVyeQ5uvMYejrFCvFd5QcZHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)