UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '07atwUeLZp0vR4HRyafGkd7cA1Vxj5CZYCl1VVV8xpc='
WHERE
key_id = '1d05cf9398732f1163628aa526d9dfe721472718d83b73abe0cba087ccd94dd7'
AND (
token = '07atwUeLZp0vR4HRyafGkd7cA1Vxj5CZYCl1VVV8xpc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)