UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kLJOsVMa9f689BJ7T98AZG0/Z5BlZ15u1YnMIwDOlH4='
WHERE
key_id = 'aafe64292ffd4aafb0012bc1162a6d4e1fa3ee32b5d60bdb209c0700ddc3a3a7'
AND (
token = 'kLJOsVMa9f689BJ7T98AZG0/Z5BlZ15u1YnMIwDOlH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)