UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/riK/VGxU9G7lN16T86YMV7j/1bEX5tr/RHfy2/7YdE='
WHERE
key_id = '1be63417d41a70ad70ce29f90b34fe01a78c13439148e9aa7709bf765d630412'
AND (
token = '/riK/VGxU9G7lN16T86YMV7j/1bEX5tr/RHfy2/7YdE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)