UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n9FEmM79C2ep1LPLFwEQzZj7DwtT8gHQ79NHHR+P+Kk='
WHERE
key_id = 'bea823da6fbdd7953a0499d155a3e3de29482656877be81d7bbf58027f9fa5e7'
AND (
token = 'n9FEmM79C2ep1LPLFwEQzZj7DwtT8gHQ79NHHR+P+Kk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)