UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aQkigROnhK+8785MIxXN2P6k4GZo7ri1eT05Mgr5qbI='
WHERE
key_id = 'ad42e0b38263d24c3fdb75177f6dbcb1ca66b4a23c687996204d8211fd8cab50'
AND (
token = 'aQkigROnhK+8785MIxXN2P6k4GZo7ri1eT05Mgr5qbI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)