UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1EGMbgmVqfW/bN9kk5Fh4eUvOBtoJAguaEJ+ScuSjw0='
WHERE
key_id = '1b27b0faed2a746cf50298a3817a1dd5fb7d61c48b0831b92ccd15fffd3b4873'
AND (
token = '1EGMbgmVqfW/bN9kk5Fh4eUvOBtoJAguaEJ+ScuSjw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)