UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DXt4QPKsJJeQ+K868hHInI6tG9dUjHHPMjC07rKAh50='
WHERE
key_id = '0ab780e5d2f992e400ff49537df3c9ab1d99ecc4baf1fe082af97c91b89d7485'
AND (
token = 'DXt4QPKsJJeQ+K868hHInI6tG9dUjHHPMjC07rKAh50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)