UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5b9truyqG5q+pfrHweSY+6hEiTO7V8++U3DWDsorVcQ='
WHERE
key_id = '12def6b4e633eb757731ef45d00ad56140f1387802d6274a6bb146ff2ed561d5'
AND (
token = '5b9truyqG5q+pfrHweSY+6hEiTO7V8++U3DWDsorVcQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)