UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CGNcAGCoxxN3eQZxivTe4KumLfwiae0Lc/78nMCyit8='
WHERE
key_id = '2199ff0c219193262afcc4f6583479a5a15370087dd1051d8f206e5360d99748'
AND (
token = 'CGNcAGCoxxN3eQZxivTe4KumLfwiae0Lc/78nMCyit8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)