UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WPhORl8nMTvFqYxSibcLGEc12d8fl7l/zd8ybRelNSI='
WHERE
key_id = 'f4b5f5af693eaa8f5298dd4ccc5ec51965d826611d4229575339f12d06be212f'
AND (
token = 'WPhORl8nMTvFqYxSibcLGEc12d8fl7l/zd8ybRelNSI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)